UPDATE epo_01_claims_from_ep_xml

SET product_by_process_2 = CASE WHEN (
  (
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'ablaufe\M')

                                    )
                                    AND
                                    (
                                      -- Exclude process & use keywords
                                      (array_to_string ((regexp_split_to_array(
                                        claim_text_, '\s+'))[1:2], ' ') !~ 'verfahren\M|methode\M|methoden\M|prozess\M|prozesse\M|prozedur\M|prozeduren\M|vorgang\M|vorgange\M|ablauf\M|ablaufe\M')
                                      AND
                                      -- Exclude use keywords
                                      (split_part(claim_text_, ' ' ,1) !~ 'verwendung\M|verwendungen\M|anwendung\M|anwendungen\M|benutzung\M|benutzungen\M|nutzung\M|nutzungen\M')
                                    )
                                  ) THEN TRUE ELSE FALSE END ,


product_by_process_5 = CASE WHEN (
    (
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mentsprechend\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\merhalten\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\merhaltlich\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgemass\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgema�\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgereinigt\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mhergestellt\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mherstellbar\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\merzeugt\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mmittels\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mubereinstimmung\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\muebereinstimmung\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mgebildet\M' and claim_text_ ~ 'ablaufe\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozedur\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozeduren\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'verfahren\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'verfahrens\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'methode\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'methoden\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozess\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'prozessen\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'vorgang\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'vorgange\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'ablauf\M') or
(claim_text_ ~ '\mvorangehenden\M' and claim_text_ ~ 'ablaufe\M')
                                    )
                                    AND
                                    (
                                      -- Exclude process keywords
                                      (array_to_string ((regexp_split_to_array(
                                        claim_text_, '\s+'))[1:5], ' ') !~ 'verfahren\M|methode\M|methoden\M|prozess\M|prozesse\M|prozedur\M|prozeduren\M|vorgang\M|vorgange\M|ablauf\M|ablaufe\M')
                                      AND
                                      -- Exclude use keywords
                                      (split_part(claim_text_, ' ' ,1) !~ 'verwendung\M|verwendungen\M|anwendung\M|anwendungen\M|benutzung\M|benutzungen\M|nutzung\M|nutzungen\M')
                                    )
                                  ) THEN TRUE ELSE FALSE END

WHERE claim_lang = 'de'
  AND claim_text IS NOT NULL
  AND claim_text != 'canceled'
  AND claim_text != ''
;
